Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 5960 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.1 MiB |
| Average record size in memory | 198.6 B |
Variable types
| Categorical | 5 |
|---|---|
| Numeric | 8 |
DEROG has constant value "0.0" | Constant |
DELINQ has constant value "0.0" | Constant |
MORTDUE is highly overall correlated with VALUE | High correlation |
VALUE is highly overall correlated with MORTDUE | High correlation |
YOJ has 415 (7.0%) zeros | Zeros |
NINQ has 2531 (42.5%) zeros | Zeros |
CLNO has 62 (1.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-26 11:17:31.199044 |
|---|---|
| Analysis finished | 2025-04-26 11:17:42.304867 |
| Duration | 11.11 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5960 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5960 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
LOAN
Real number (ℝ)
| Distinct | 390 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18051.896 |
| Minimum | 1100 |
|---|---|
| Maximum | 41600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 1100 |
|---|---|
| 5-th percentile | 5900 |
| Q1 | 11100 |
| median | 16300 |
| Q3 | 23300 |
| 95-th percentile | 40000 |
| Maximum | 41600 |
| Range | 40500 |
| Interquartile range (IQR) | 12200 |
Descriptive statistics
| Standard deviation | 9252.5653 |
|---|---|
| Coefficient of variation (CV) | 0.51255366 |
| Kurtosis | 0.27308773 |
| Mean | 18051.896 |
| Median Absolute Deviation (MAD) | 6000 |
| Skewness | 0.83238935 |
| Sum | 1.075893 × 108 |
| Variance | 85609965 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 41600 | 260 | 4.4% |
| 15000 | 105 | 1.8% |
| 10000 | 81 | 1.4% |
| 20000 | 74 | 1.2% |
| 25000 | 73 | 1.2% |
| 12000 | 69 | 1.2% |
| 17000 | 51 | 0.9% |
| 5000 | 50 | 0.8% |
| 13000 | 50 | 0.8% |
| 11000 | 47 | 0.8% |
| Other values (380) | 5100 |
| Value | Count | Frequency (%) |
| 1100 | 1 | < 0.1% |
| 1300 | 1 | < 0.1% |
| 1500 | 2 | < 0.1% |
| 1700 | 2 | < 0.1% |
| 1800 | 2 | < 0.1% |
| 2000 | 6 | |
| 2100 | 1 | < 0.1% |
| 2200 | 3 | |
| 2300 | 3 | |
| 2400 | 6 |
| Value | Count | Frequency (%) |
| 41600 | 260 | |
| 41500 | 1 | < 0.1% |
| 41400 | 2 | < 0.1% |
| 41300 | 1 | < 0.1% |
| 41200 | 3 | 0.1% |
| 41100 | 3 | 0.1% |
| 40900 | 5 | 0.1% |
| 40800 | 2 | < 0.1% |
| 40700 | 3 | 0.1% |
| 40600 | 3 | 0.1% |
MORTDUE
Real number (ℝ)
High correlation
| Distinct | 4755 |
|---|---|
| Distinct (%) | 79.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70517.314 |
| Minimum | 2063 |
|---|---|
| Maximum | 148292.12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 2063 |
|---|---|
| 5-th percentile | 19105.45 |
| Q1 | 48139 |
| median | 65019 |
| Q3 | 88200.25 |
| 95-th percentile | 148292.12 |
| Maximum | 148292.12 |
| Range | 146229.12 |
| Interquartile range (IQR) | 40061.25 |
Descriptive statistics
| Standard deviation | 34463.827 |
|---|---|
| Coefficient of variation (CV) | 0.48872859 |
| Kurtosis | -0.04794925 |
| Mean | 70517.314 |
| Median Absolute Deviation (MAD) | 19129 |
| Skewness | 0.61659244 |
| Sum | 4.2028319 × 108 |
| Variance | 1.1877554 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 65019 | 518 | 8.7% |
| 148292.125 | 308 | 5.2% |
| 42000 | 11 | 0.2% |
| 47000 | 10 | 0.2% |
| 65000 | 9 | 0.2% |
| 50000 | 7 | 0.1% |
| 124000 | 7 | 0.1% |
| 55000 | 7 | 0.1% |
| 62000 | 7 | 0.1% |
| 45000 | 7 | 0.1% |
| Other values (4745) | 5069 |
| Value | Count | Frequency (%) |
| 2063 | 1 | |
| 2619 | 1 | |
| 2800 | 1 | |
| 3372 | 1 | |
| 4000 | 1 | |
| 4447 | 1 | |
| 4500 | 1 | |
| 4641 | 1 | |
| 4734 | 1 | |
| 4742 | 1 |
| Value | Count | Frequency (%) |
| 148292.125 | 308 | |
| 148235 | 1 | < 0.1% |
| 147855 | 1 | < 0.1% |
| 147801 | 1 | < 0.1% |
| 147696 | 1 | < 0.1% |
| 147638 | 1 | < 0.1% |
| 147622 | 1 | < 0.1% |
| 147600 | 1 | < 0.1% |
| 147577 | 1 | < 0.1% |
| 147522 | 1 | < 0.1% |
VALUE
Real number (ℝ)
High correlation
| Distinct | 5048 |
|---|---|
| Distinct (%) | 84.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98212.468 |
| Minimum | 8000 |
|---|---|
| Maximum | 197777.62 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 8000 |
|---|---|
| 5-th percentile | 39260.8 |
| Q1 | 66489.5 |
| median | 89235.5 |
| Q3 | 119004.75 |
| 95-th percentile | 197777.62 |
| Maximum | 197777.62 |
| Range | 189777.62 |
| Interquartile range (IQR) | 52515.25 |
Descriptive statistics
| Standard deviation | 44321.429 |
|---|---|
| Coefficient of variation (CV) | 0.45128109 |
| Kurtosis | -0.10474873 |
| Mean | 98212.468 |
| Median Absolute Deviation (MAD) | 25427 |
| Skewness | 0.77114258 |
| Sum | 5.8534631 × 108 |
| Variance | 1.9643891 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 197777.625 | 347 | 5.8% |
| 89235.5 | 112 | 1.9% |
| 60000 | 15 | 0.3% |
| 80000 | 14 | 0.2% |
| 85000 | 12 | 0.2% |
| 65000 | 11 | 0.2% |
| 78000 | 10 | 0.2% |
| 72000 | 9 | 0.2% |
| 50000 | 8 | 0.1% |
| 68000 | 8 | 0.1% |
| Other values (5038) | 5414 |
| Value | Count | Frequency (%) |
| 8000 | 1 | |
| 8800 | 1 | |
| 9100 | 1 | |
| 9500 | 1 | |
| 11550 | 1 | |
| 11702 | 1 | |
| 12414 | 1 | |
| 12500 | 1 | |
| 12737 | 1 | |
| 12972 | 1 |
| Value | Count | Frequency (%) |
| 197777.625 | 347 | |
| 197722 | 1 | < 0.1% |
| 197634 | 1 | < 0.1% |
| 197592 | 1 | < 0.1% |
| 197500 | 1 | < 0.1% |
| 196968 | 1 | < 0.1% |
| 196860 | 1 | < 0.1% |
| 196555 | 1 | < 0.1% |
| 196335 | 1 | < 0.1% |
| 196270 | 1 | < 0.1% |
REASON
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 327.5 KiB |
| DebtCon | |
|---|---|
| HomeImp | |
| Not Specified | 252 |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 7.2536913 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HomeImp |
|---|---|
| 2nd row | HomeImp |
| 3rd row | HomeImp |
| 4th row | Not Specified |
| 5th row | HomeImp |
Common Values
| Value | Count | Frequency (%) |
| DebtCon | 3928 | |
| HomeImp | 1780 | |
| Not Specified | 252 | 4.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| debtcon | 3928 | |
| homeimp | 1780 | |
| not | 252 | 4.1% |
| specified | 252 | 4.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6212 | |
| o | 5960 | |
| t | 4180 | |
| D | 3928 | |
| b | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| p | 2032 | 4.7% |
| I | 1780 | 4.1% |
| Other values (8) | 3796 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 31060 | |
| Uppercase Letter | 11920 | 27.6% |
| Space Separator | 252 | 0.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 6212 | |
| o | 5960 | |
| t | 4180 | |
| b | 3928 | |
| n | 3928 | |
| m | 3560 | |
| p | 2032 | 6.5% |
| i | 504 | 1.6% |
| c | 252 | 0.8% |
| f | 252 | 0.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 3928 | |
| C | 3928 | |
| I | 1780 | |
| H | 1780 | |
| N | 252 | 2.1% |
| S | 252 | 2.1% |
Space Separator
| Value | Count | Frequency (%) |
| 252 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42980 | |
| Common | 252 | 0.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 6212 | |
| o | 5960 | |
| t | 4180 | |
| D | 3928 | |
| b | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| p | 2032 | 4.7% |
| I | 1780 | 4.1% |
| Other values (7) | 3544 |
Common
| Value | Count | Frequency (%) |
| 252 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43232 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 6212 | |
| o | 5960 | |
| t | 4180 | |
| D | 3928 | |
| b | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| p | 2032 | 4.7% |
| I | 1780 | 4.1% |
| Other values (8) | 3796 |
JOB
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 316.4 KiB |
| Other | |
|---|---|
| ProfExe | |
| Office | |
| Mgr | |
| No Job | |
| Other values (2) |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.3442953 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Other |
|---|---|
| 2nd row | Other |
| 3rd row | Other |
| 4th row | No Job |
| 5th row | Office |
Common Values
| Value | Count | Frequency (%) |
| Other | 2388 | |
| ProfExe | 1276 | |
| Office | 948 | 15.9% |
| Mgr | 767 | 12.9% |
| No Job | 279 | 4.7% |
| Self | 193 | 3.2% |
| Sales | 109 | 1.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| other | 2388 | |
| profexe | 1276 | |
| office | 948 | 15.2% |
| mgr | 767 | 12.3% |
| no | 279 | 4.5% |
| job | 279 | 4.5% |
| self | 193 | 3.1% |
| sales | 109 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| t | 2388 | |
| h | 2388 | |
| o | 1834 | 5.8% |
| P | 1276 | 4.0% |
| E | 1276 | 4.0% |
| x | 1276 | 4.0% |
| Other values (12) | 5368 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 24058 | |
| Uppercase Letter | 7515 | 23.6% |
| Space Separator | 279 | 0.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| t | 2388 | |
| h | 2388 | |
| o | 1834 | 7.6% |
| x | 1276 | 5.3% |
| c | 948 | 3.9% |
| i | 948 | 3.9% |
| g | 767 | 3.2% |
| Other values (4) | 799 | 3.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 3336 | |
| P | 1276 | 17.0% |
| E | 1276 | 17.0% |
| M | 767 | 10.2% |
| S | 302 | 4.0% |
| N | 279 | 3.7% |
| J | 279 | 3.7% |
Space Separator
| Value | Count | Frequency (%) |
| 279 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 31573 | |
| Common | 279 | 0.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| t | 2388 | |
| h | 2388 | |
| o | 1834 | 5.8% |
| P | 1276 | 4.0% |
| E | 1276 | 4.0% |
| x | 1276 | 4.0% |
| Other values (11) | 5089 |
Common
| Value | Count | Frequency (%) |
| 279 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31852 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| t | 2388 | |
| h | 2388 | |
| o | 1834 | 5.8% |
| P | 1276 | 4.0% |
| E | 1276 | 4.0% |
| x | 1276 | 4.0% |
| Other values (12) | 5368 |
YOJ
Real number (ℝ)
Zeros
| Distinct | 86 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.6451091 |
| Minimum | 0 |
|---|---|
| Maximum | 25.5 |
| Zeros | 415 |
| Zeros (%) | 7.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 7 |
| Q3 | 12 |
| 95-th percentile | 24 |
| Maximum | 25.5 |
| Range | 25.5 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 6.9532653 |
|---|---|
| Coefficient of variation (CV) | 0.80430048 |
| Kurtosis | 0.00056679553 |
| Mean | 8.6451091 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.90561204 |
| Sum | 51524.85 |
| Variance | 48.347899 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7 | 759 | 12.7% |
| 0 | 415 | 7.0% |
| 1 | 363 | 6.1% |
| 2 | 347 | 5.8% |
| 5 | 333 | 5.6% |
| 4 | 324 | 5.4% |
| 6 | 318 | 5.3% |
| 3 | 307 | 5.2% |
| 9 | 286 | 4.8% |
| 10 | 285 | 4.8% |
| Other values (76) | 2223 |
| Value | Count | Frequency (%) |
| 0 | 415 | |
| 0.1 | 14 | 0.2% |
| 0.2 | 10 | 0.2% |
| 0.25 | 1 | < 0.1% |
| 0.3 | 7 | 0.1% |
| 0.4 | 9 | 0.2% |
| 0.5 | 7 | 0.1% |
| 0.6 | 4 | 0.1% |
| 0.7 | 4 | 0.1% |
| 0.75 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 25.5 | 211 | |
| 25 | 56 | 0.9% |
| 24.5 | 1 | < 0.1% |
| 24 | 75 | 1.3% |
| 23 | 77 | 1.3% |
| 22.8 | 1 | < 0.1% |
| 22 | 67 | 1.1% |
| 21 | 69 | 1.2% |
| 20 | 82 | 1.4% |
| 19.5 | 1 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 5960 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 5960 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11920 | |
| . | 5960 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11920 | |
| Other Punctuation | 5960 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11920 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5960 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17880 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 11920 | |
| . | 5960 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17880 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11920 | |
| . | 5960 |
DELINQ
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 302.8 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 5960 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 5960 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11920 | |
| . | 5960 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11920 | |
| Other Punctuation | 5960 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11920 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5960 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17880 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 11920 | |
| . | 5960 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17880 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11920 | |
| . | 5960 |
CLAGE
Real number (ℝ)
| Distinct | 5249 |
|---|---|
| Distinct (%) | 88.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 178.22661 |
| Minimum | 0 |
|---|---|
| Maximum | 391.8005 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 69.644236 |
| Q1 | 117.37143 |
| median | 173.46667 |
| Q3 | 227.14306 |
| 95-th percentile | 319.65841 |
| Maximum | 391.8005 |
| Range | 391.8005 |
| Interquartile range (IQR) | 109.77163 |
Descriptive statistics
| Standard deviation | 77.995604 |
|---|---|
| Coefficient of variation (CV) | 0.43762043 |
| Kurtosis | -0.22653164 |
| Mean | 178.22661 |
| Median Absolute Deviation (MAD) | 55.293364 |
| Skewness | 0.48368095 |
| Sum | 1062230.6 |
| Variance | 6083.3143 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 173.4666667 | 310 | 5.2% |
| 391.8005003 | 66 | 1.1% |
| 206.9666667 | 7 | 0.1% |
| 102.5 | 7 | 0.1% |
| 95.36666667 | 6 | 0.1% |
| 123.7666667 | 6 | 0.1% |
| 109.5666667 | 6 | 0.1% |
| 177.5 | 6 | 0.1% |
| 219.1333333 | 5 | 0.1% |
| 304.3666667 | 5 | 0.1% |
| Other values (5239) | 5536 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 0.4867114508 | 1 | |
| 0.5071145295 | 1 | |
| 2.033333333 | 1 | |
| 2.820785578 | 1 | |
| 3.04438414 | 1 | |
| 4.412770061 | 1 | |
| 5.243341044 | 1 | |
| 6.133333333 | 1 | |
| 8.055265077 | 1 |
| Value | Count | Frequency (%) |
| 391.8005003 | 66 | |
| 385.5 | 1 | < 0.1% |
| 384.5 | 1 | < 0.1% |
| 384.2850469 | 1 | < 0.1% |
| 382.8588359 | 1 | < 0.1% |
| 382.312217 | 1 | < 0.1% |
| 381.0256475 | 1 | < 0.1% |
| 380.2780405 | 1 | < 0.1% |
| 379.3499549 | 1 | < 0.1% |
| 378.8258185 | 1 | < 0.1% |
NINQ
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0854027 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 2531 |
| Zeros (%) | 42.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.3128977 |
|---|---|
| Coefficient of variation (CV) | 1.209595 |
| Kurtosis | 1.507957 |
| Mean | 1.0854027 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.4160463 |
| Sum | 6469 |
| Variance | 1.7237003 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 2531 | |
| 1 | 1849 | |
| 2 | 780 | 13.1% |
| 3 | 392 | 6.6% |
| 5 | 252 | 4.2% |
| 4 | 156 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 2531 | |
| 1 | 1849 | |
| 2 | 780 | 13.1% |
| 3 | 392 | 6.6% |
| 4 | 156 | 2.6% |
| 5 | 252 | 4.2% |
| Value | Count | Frequency (%) |
| 5 | 252 | 4.2% |
| 4 | 156 | 2.6% |
| 3 | 392 | 6.6% |
| 2 | 780 | 13.1% |
| 1 | 1849 | |
| 0 | 2531 |
CLNO
Real number (ℝ)
Zeros
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.994379 |
| Minimum | 0 |
|---|---|
| Maximum | 42.5 |
| Zeros | 62 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 15 |
| median | 20 |
| Q3 | 26 |
| 95-th percentile | 40 |
| Maximum | 42.5 |
| Range | 42.5 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 9.2451696 |
|---|---|
| Coefficient of variation (CV) | 0.44036404 |
| Kurtosis | -0.061870947 |
| Mean | 20.994379 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.37976359 |
| Sum | 125126.5 |
| Variance | 85.47316 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=44)
| Value | Count | Frequency (%) |
| 20 | 453 | 7.6% |
| 16 | 316 | 5.3% |
| 19 | 307 | 5.2% |
| 24 | 264 | 4.4% |
| 23 | 259 | 4.3% |
| 21 | 235 | 3.9% |
| 18 | 225 | 3.8% |
| 25 | 221 | 3.7% |
| 42.5 | 219 | 3.7% |
| 15 | 217 | 3.6% |
| Other values (34) | 3244 |
| Value | Count | Frequency (%) |
| 0 | 62 | |
| 1 | 6 | 0.1% |
| 2 | 15 | 0.3% |
| 3 | 34 | 0.6% |
| 4 | 42 | 0.7% |
| 5 | 47 | 0.8% |
| 6 | 60 | |
| 7 | 76 | |
| 8 | 92 | |
| 9 | 127 |
| Value | Count | Frequency (%) |
| 42.5 | 219 | |
| 42 | 42 | 0.7% |
| 41 | 24 | 0.4% |
| 40 | 20 | 0.3% |
| 39 | 20 | 0.3% |
| 38 | 39 | 0.7% |
| 37 | 50 | 0.8% |
| 36 | 70 | 1.2% |
| 35 | 78 | 1.3% |
| 34 | 89 |
DEBTINC
Real number (ℝ)
| Distinct | 4448 |
|---|---|
| Distinct (%) | 74.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.999967 |
| Minimum | 19.98306 |
|---|---|
| Maximum | 48.729991 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 19.98306 |
|---|---|
| 5-th percentile | 21.469701 |
| Q1 | 30.763159 |
| median | 34.818262 |
| Q3 | 37.949892 |
| 95-th percentile | 42.325285 |
| Maximum | 48.729991 |
| Range | 28.74693 |
| Interquartile range (IQR) | 7.1867326 |
Descriptive statistics
| Standard deviation | 5.9536461 |
|---|---|
| Coefficient of variation (CV) | 0.17510741 |
| Kurtosis | 0.091355396 |
| Mean | 33.999967 |
| Median Absolute Deviation (MAD) | 3.5015052 |
| Skewness | -0.53440133 |
| Sum | 202639.8 |
| Variance | 35.445901 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34.81826182 | 1268 | 21.3% |
| 19.98306047 | 198 | 3.3% |
| 48.72999084 | 49 | 0.8% |
| 38.14905923 | 1 | < 0.1% |
| 39.91928991 | 1 | < 0.1% |
| 35.61202481 | 1 | < 0.1% |
| 38.18834501 | 1 | < 0.1% |
| 44.38257789 | 1 | < 0.1% |
| 34.96414103 | 1 | < 0.1% |
| 43.64534866 | 1 | < 0.1% |
| Other values (4438) | 4438 |
| Value | Count | Frequency (%) |
| 19.98306047 | 198 | |
| 20.01032357 | 1 | < 0.1% |
| 20.02628441 | 1 | < 0.1% |
| 20.0283535 | 1 | < 0.1% |
| 20.05952718 | 1 | < 0.1% |
| 20.06704205 | 1 | < 0.1% |
| 20.07933438 | 1 | < 0.1% |
| 20.09078333 | 1 | < 0.1% |
| 20.09904978 | 1 | < 0.1% |
| 20.11698202 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 48.72999084 | 49 | |
| 48.56957404 | 1 | < 0.1% |
| 48.34023474 | 1 | < 0.1% |
| 48.27759122 | 1 | < 0.1% |
| 48.07753147 | 1 | < 0.1% |
| 47.91511242 | 1 | < 0.1% |
| 47.91452111 | 1 | < 0.1% |
| 47.84029512 | 1 | < 0.1% |
| 47.83067113 | 1 | < 0.1% |
| 47.79590611 | 1 | < 0.1% |
Interactions
Correlations
| BAD | CLAGE | CLNO | DEBTINC | JOB | LOAN | MORTDUE | NINQ | REASON | VALUE | YOJ | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| BAD | 1.000 | 0.183 | 0.117 | 0.472 | 0.131 | 0.185 | 0.086 | 0.178 | 0.033 | 0.125 | 0.101 |
| CLAGE | 0.183 | 1.000 | 0.233 | 0.012 | 0.147 | 0.119 | 0.119 | -0.096 | 0.163 | 0.183 | 0.159 |
| CLNO | 0.117 | 0.233 | 1.000 | 0.159 | 0.158 | 0.141 | 0.319 | 0.140 | 0.137 | 0.355 | 0.045 |
| DEBTINC | 0.472 | 0.012 | 0.159 | 1.000 | 0.093 | 0.098 | 0.139 | 0.147 | 0.113 | 0.133 | -0.053 |
| JOB | 0.131 | 0.147 | 0.158 | 0.093 | 1.000 | 0.110 | 0.173 | 0.098 | 0.284 | 0.175 | 0.107 |
| LOAN | 0.185 | 0.119 | 0.141 | 0.098 | 0.110 | 1.000 | 0.184 | 0.036 | 0.235 | 0.340 | 0.089 |
| MORTDUE | 0.086 | 0.119 | 0.319 | 0.139 | 0.173 | 0.184 | 1.000 | 0.052 | 0.123 | 0.792 | -0.050 |
| NINQ | 0.178 | -0.096 | 0.140 | 0.147 | 0.098 | 0.036 | 0.052 | 1.000 | 0.125 | 0.003 | -0.062 |
| REASON | 0.033 | 0.163 | 0.137 | 0.113 | 0.284 | 0.235 | 0.123 | 0.125 | 1.000 | 0.075 | 0.127 |
| VALUE | 0.125 | 0.183 | 0.355 | 0.133 | 0.175 | 0.340 | 0.792 | 0.003 | 0.075 | 1.000 | 0.032 |
| YOJ | 0.101 | 0.159 | 0.045 | -0.053 | 0.107 | 0.089 | -0.050 | -0.062 | 0.127 | 0.032 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| BAD | LOAN | MORTDUE | VALUE | REASON | JOB | YOJ | DEROG | DELINQ | CLAGE | NINQ | CLNO | DEBTINC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1100.0 | 25860.0 | 39025.0 | HomeImp | Other | 10.5 | 0.0 | 0.0 | 94.366667 | 1.0 | 9.0 | 34.818262 |
| 1 | 1 | 1300.0 | 70053.0 | 68400.0 | HomeImp | Other | 7.0 | 0.0 | 0.0 | 121.833333 | 0.0 | 14.0 | 34.818262 |
| 2 | 1 | 1500.0 | 13500.0 | 16700.0 | HomeImp | Other | 4.0 | 0.0 | 0.0 | 149.466667 | 1.0 | 10.0 | 34.818262 |
| 3 | 1 | 1500.0 | 65019.0 | 89235.5 | Not Specified | No Job | 7.0 | 0.0 | 0.0 | 173.466667 | 1.0 | 20.0 | 34.818262 |
| 4 | 0 | 1700.0 | 97800.0 | 112000.0 | HomeImp | Office | 3.0 | 0.0 | 0.0 | 93.333333 | 0.0 | 14.0 | 34.818262 |
| 5 | 1 | 1700.0 | 30548.0 | 40320.0 | HomeImp | Other | 9.0 | 0.0 | 0.0 | 101.466002 | 1.0 | 8.0 | 37.113614 |
| 6 | 1 | 1800.0 | 48649.0 | 57037.0 | HomeImp | Other | 5.0 | 0.0 | 0.0 | 77.100000 | 1.0 | 17.0 | 34.818262 |
| 7 | 1 | 1800.0 | 28502.0 | 43034.0 | HomeImp | Other | 11.0 | 0.0 | 0.0 | 88.766030 | 0.0 | 8.0 | 36.884894 |
| 8 | 1 | 2000.0 | 32700.0 | 46740.0 | HomeImp | Other | 3.0 | 0.0 | 0.0 | 216.933333 | 1.0 | 12.0 | 34.818262 |
| 9 | 1 | 2000.0 | 65019.0 | 62250.0 | HomeImp | Sales | 16.0 | 0.0 | 0.0 | 115.800000 | 0.0 | 13.0 | 34.818262 |
| BAD | LOAN | MORTDUE | VALUE | REASON | JOB | YOJ | DEROG | DELINQ | CLAGE | NINQ | CLNO | DEBTINC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5950 | 0 | 41600.0 | 55938.0 | 86794.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 223.881040 | 0.0 | 16.0 | 36.753653 |
| 5951 | 0 | 41600.0 | 54004.0 | 94838.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 193.702051 | 0.0 | 15.0 | 36.262691 |
| 5952 | 0 | 41600.0 | 50240.0 | 94687.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 214.426206 | 0.0 | 16.0 | 34.751158 |
| 5953 | 0 | 41600.0 | 53307.0 | 94058.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 218.304978 | 0.0 | 15.0 | 34.242465 |
| 5954 | 0 | 41600.0 | 48919.0 | 93371.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 205.650159 | 0.0 | 15.0 | 34.818262 |
| 5955 | 0 | 41600.0 | 57264.0 | 90185.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 221.808718 | 0.0 | 16.0 | 36.112347 |
| 5956 | 0 | 41600.0 | 54576.0 | 92937.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 208.692070 | 0.0 | 15.0 | 35.859971 |
| 5957 | 0 | 41600.0 | 54045.0 | 92924.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 212.279697 | 0.0 | 15.0 | 35.556590 |
| 5958 | 0 | 41600.0 | 50370.0 | 91861.0 | DebtCon | Other | 14.0 | 0.0 | 0.0 | 213.892709 | 0.0 | 16.0 | 34.340882 |
| 5959 | 0 | 41600.0 | 48811.0 | 88934.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 219.601002 | 0.0 | 16.0 | 34.571519 |